2013-03-25 - 5910.200 - Rel Notes - Contracts - Release 014 #BIReleases2013
Release Notes:
5910.200 - Contracts - SA200
Admin Info
Purpose
|
Including Contract Information in SA200 report
|
Release No
|
014
|
Submitted
|
03-25-2013
|
Submitted by
|
Mallareddy D
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Narendra K
|
Object(s) Tested By
|
Narendra K
|
Report Name
SA200 - Sales Analysis by Region, Sales Org, SBU and Customer.
BEx Query
ZMP_OPASA_Q015
NEC Crystal Reports Standards Check
1. SA200 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA200 NEC CR checklist has been sent to NEC and also attached here for reference.
SA200 NEC CR Standard Check List.xlsx
Summary Level Check
Test Conducted
Restricted Region at Query Level: Emerging Market
Report Header
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
112,564
|
112,564
|
Pass
|
2
|
Ship Rev
|
1,616,463
|
1,616,463
|
Pass
|
3
|
Open Qty
|
425
|
425
|
Pass
|
4
|
Open Rev
|
5,523
|
5,523
|
Pass
|
5
|
Cost
|
488,797
|
488,797
|
Pass
|
6
|
Comm
|
9,998
|
9,998
|
Pass
|
7
|
Royalty
|
223,577
|
223,577
|
Pass
|
8
|
Contrib
|
894,091
|
894,091
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
103,180
|
103,180
|
Pass
|
2
|
Ship Rev
|
1,403,166
|
1,403,166
|
Pass
|
3
|
Open Qty
|
60,000
|
60,000
|
Pass
|
4
|
Open Rev
|
882,953
|
882,953
|
Pass
|
5
|
Cost
|
503,264
|
503,264
|
Pass
|
6
|
Comm
|
8,287
|
8,287
|
Pass
|
7
|
Royalty
|
202,159
|
202,159
|
Pass
|
8
|
Contrib
|
689,456
|
689,456
|
Pass
|
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
59,057
|
59,057
|
Pass
|
2
|
Ship Rev
|
835,799
|
835,799
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
252,715
|
252,715
|
Pass
|
6
|
Comm
|
6,073
|
6,073
|
Pass
|
7
|
Royalty
|
133,778
|
133,778
|
Pass
|
8
|
Contrib
|
443,232
|
443,232
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
168,503
|
168,503
|
Pass
|
2
|
Ship Rev
|
2,160,878
|
2,160,878
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
689,877
|
689,877
|
Pass
|
6
|
Comm
|
10,478
|
10,478
|
Pass
|
7
|
Royalty
|
333,818
|
333,818
|
Pass
|
8
|
Contrib
|
1,126,705
|
1,126,705
|
Pass
|
Without Restricted Region at Query Level but Restricted at Report Level: Emerging Market
Report Header
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
69,616
|
112,564
|
Fail
|
2
|
Ship Rev
|
896,364
|
1,616,463
|
Fail
|
3
|
Open Qty
|
192
|
425
|
Fail
|
4
|
Open Rev
|
1,882
|
5,523
|
Fail
|
5
|
Cost
|
311,653
|
488,797
|
Fail
|
6
|
Comm
|
7,963
|
9,998
|
Fail
|
7
|
Royalty
|
108,316
|
223,577
|
Fail
|
8
|
Contrib
|
468,431
|
894,091
|
Fail
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
58,348
|
103,180
|
Fail
|
2
|
Ship Rev
|
717,034
|
1,403,166
|
Fail
|
3
|
Open Qty
|
21,585
|
60,000
|
Fail
|
4
|
Open Rev
|
211,876
|
882,953
|
Fail
|
5
|
Cost
|
236,166
|
503,264
|
Fail
|
6
|
Comm
|
6,758
|
8,287
|
Fail
|
7
|
Royalty
|
96,110
|
202,159
|
Fail
|
8
|
Contrib
|
377,999
|
689,456
|
Fail
|
NOTE: Even though all the above test cases failed, we considered them as successfully validated. This is because the same report validated correctly, when we restricted the data in BEx.
So we concluded that this issue is because of One million records limitation.
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
59,057
|
59,057
|
Pass
|
2
|
Ship Rev
|
835,799
|
835,799
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
252,715
|
252,715
|
Pass
|
6
|
Comm
|
6,073
|
6,073
|
Pass
|
7
|
Royalty
|
133,778
|
133,778
|
Pass
|
8
|
Contrib
|
443,232
|
443,232
|
Pass
|
Period - March
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
168,503
|
168,503
|
Pass
|
2
|
Ship Rev
|
2,160,878
|
2,160,878
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
689,877
|
689,877
|
Pass
|
6
|
Comm
|
10,478
|
10,478
|
Pass
|
7
|
Royalty
|
333,818
|
333,818
|
Pass
|
8
|
Contrib
|
1,126,705
|
1,126,705
|
Pass
|
Second level check
Grouping: Region > Sales Org > SBU > Customer
Test Conducted
Group: Emerging Markets
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
112,564
|
112,564
|
Pass
|
2
|
Ship Rev
|
1,616,463
|
1,616,463
|
Pass
|
3
|
Open Qty
|
425
|
425
|
Pass
|
4
|
Open Rev
|
5,523
|
5,523
|
Pass
|
5
|
Cost
|
488,797
|
488,797
|
Pass
|
6
|
Comm
|
9,998
|
9,998
|
Pass
|
7
|
Royalty
|
223,577
|
223,577
|
Pass
|
8
|
Contrib
|
894,091
|
894,091
|
Pass
|
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
59,057
|
59,057
|
Pass
|
2
|
Ship Rev
|
835,799
|
835,799
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
252,715
|
252,715
|
Pass
|
6
|
Comm
|
6,073
|
6,073
|
Pass
|
7
|
Royalty
|
133,778
|
133,778
|
Pass
|
8
|
Contrib
|
443,232
|
443,232
|
Pass
|
Third Level Check
Test Conducted
Group: Emerging Markets > Australia Sales
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
13,063
|
13,063
|
Pass
|
2
|
Ship Rev
|
272,973
|
272,973
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
62,605
|
62,605
|
Pass
|
6
|
Comm
|
9,386
|
9,386
|
Pass
|
7
|
Royalty
|
37,591
|
37,591
|
Pass
|
8
|
Contrib
|
163,392
|
163,392
|
Pass
|
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
11,323
|
11,323
|
Pass
|
2
|
Ship Rev
|
243,910
|
243,910
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
39,317
|
39,317
|
Pass
|
6
|
Comm
|
5,871
|
5,871
|
Pass
|
7
|
Royalty
|
37,960
|
37,960
|
Pass
|
8
|
Contrib
|
160,763
|
160,763
|
Pass
|
Fourth Level Check
Test Conducted
Group: Emerging Markets > Australia Sales > ACCESSORIES
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
180
|
180
|
Pass
|
2
|
Ship Rev
|
5,468
|
5,468
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
2,666
|
2,666
|
Pass
|
6
|
Comm
|
154
|
154
|
Pass
|
7
|
Royalty
|
0
|
0
|
Pass
|
8
|
Contrib
|
2,648
|
2,648
|
Pass
|
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
360
|
360
|
Pass
|
2
|
Ship Rev
|
575
|
575
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
1,256
|
1,256
|
Pass
|
6
|
Comm
|
22
|
22
|
Pass
|
7
|
Royalty
|
0
|
0
|
Pass
|
8
|
Contrib
|
-703
|
-703
|
Pass
|
Fifth Level Check
Test Conducted
Group: Emerging Markets > Australia Sales > ACCESSORIES > CULTURE KINGS-1011913
Year 2013
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
44
|
44
|
Pass
|
2
|
Ship Rev
|
3,718
|
3,718
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
1,295
|
1,295
|
Pass
|
6
|
Comm
|
149
|
149
|
Pass
|
7
|
Royalty
|
0
|
0
|
Pass
|
8
|
Contrib
|
2,274
|
2,274
|
Pass
|
Year 2012
Period - January
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ship Qty
|
324
|
324
|
Pass
|
2
|
Ship Rev
|
522
|
522
|
Pass
|
3
|
Open Qty
|
0
|
0
|
Pass
|
4
|
Open Rev
|
0
|
0
|
Pass
|
5
|
Cost
|
1,173
|
1,173
|
Pass
|
6
|
Comm
|
21
|
21
|
Pass
|
7
|
Royalty
|
0
|
0
|
Pass
|
8
|
Contrib
|
-672
|
-672
|
Pass
|
Reference Document (Specification)
2013-03-15 - 5910.200 - Spec - Contract Reports